Use this function to split the displayed asset to generate 1 to n additional assets.
It is accessed from the Actions menu in the Assets management function.

Note: You cannot split an asset if it meets at least one of the following requirements:
- It is Inactive.
- Its holding type is In template.
- It is classified as for sale.
- It has been subject to an actual asset issue.
- It is in the process of an intra-group transfer.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

This window is made up of a header displaying, as a reminder, the identification of the asset as well as the following two tabs:

- the Parameters tab that is used to enter the asset splitting parameters, then to view the assets generated as a result of the split.

- the Linked expenses tab displays the expenses linked to the asset and, in case of a split by expense, it is used to select the expenses to be linked to the generated asset.

Header

Presentation

The header displays the reference and the description of the asset to be split. The information in this field cannot be modified.

Close

 

Fields

The following fields are present on this tab :

Business object

  • Reference (field OBJREF)

Reference of the financial asset to split.

  • Description (field OBJDES)

Description of the financial asset to split.

Close

 

Tab Setup definition

Presentation

This tab is used:

  • To specify the date of the split (this date, which is mandatory, is loaded by default with the current date) as well as the reason that justifies the split for the asset.
     
  • To set up the terms of the split by specifying:
    - if the split is done by quantity, amount or expense,
    - by entering the number of assets expected at the end of the split,
    - by specifying the numbering type to apply to the assets coming from the split.
     
  • To apply the process and view the result:list of assets from the split and the situation of the split financial asset at the end of process.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Split date (field MVTDAT)

This field is used to enter the transaction date. This mandatory date is displayed in the corresponding event(s).

This field displays the reason for the current transaction. This information is mandatory.

This field displays the company management currency, as a reminder.

This field displays the IFRS currency in the IAS depreciation plan for a company.

Split

  • By (field SPLBAS)

Option button enabling the user to precise if the splitting must be done according to the asset quantity, the amount or the expenses linked to the asset to split.

  • Amount (field SPLAMTTYP)

This field can be accessed only when the splitting is based on the distribution of an amount. It enables the user to precise the type of amount selected.

Block number 3

  • In (field NBFAS)

This field enables the user to indicate the total number of assets obtained at the end of the explosion (including the original asset).

  • The maximum number of assets is limited to 999 if the explosion is performed according to amount distribution.
  • It is limited to the original asset quantity if the explosion is performed according to quantity distribution.
  • If the explosion is carried out according to expense distribution, it corresponds to the number of expenses attached to the asset. In this case, it can be modified, but the only possible value is 2.
  • Distribute qty (field QTYSPL)

This flag is used to specify whether the quantity must distributed on the created records or copied.

  • Distribute in %age (field PRCFLG)

This flag can only be accessed when the split is carried out in relation to the amount.
It authorizes, when activated, the modification of the distribution percentage calculated on each asset coming from the split.

  • Split expenses (field LOFSPLFLG)

This flag is only used if expenses are split by quantity or by amount.
When activated, it enables expenses linked to the split asset to be split. Each asset created further to the expense split will be associated with as many linked expenses as the original asset.
When it is not activated, expenses remain linked to the original asset. The assets created further to the expense split have no linked expenses.

Asset before

  • Quantity (field QTYBEF)
This is the quantity linked to the financial asset to be split before the actual splitting. This information cannot be modified.
  • Amount (field SPLAMTBEF)

It is the amount of the financial asset to split before the splitting operation.
Non modifiable information.

Asset after

  • Quantity (field QTYAFT)
This is the residual quantity of the split asset once the splitting is complete. This information cannot be modified. 
  • Amount (field SPLAMTAFT)

It is the amount of the finanial asset to split at the end of the splitting operation.
Non modifiable information.

  • % (field SPLPRCAFT)

It is the percentage of the initial amount allocated to the original fixed asset, at the end of the split.
This information cannot be modified.

Numbering for split

  • Numbering (field TYPNUM)

This field is used to indicate the numbering method to use on the assets created by the split.
Several options are available:

  • None means that the reference of the assets coming from the split will have to be entered. The Increment field cannot be accessed then.
  • Addition of a numeric increment means that the number will be determined by the number of the asset at the origin of the split to which the value determined by the Increment entered will be added.
  • New number means that the reference of each asset stemming from the split will be automatically determined if the automatic numbering is mandatory. If it is optional, the reference can be entered.
  • Increment (field LIGINC)
This field is used to define the increment number applied to the source asset reference in order to generate the references of the financial assets created by the split.
It can only be entered if the Numbering for split field is set to: Add a numeric increment.   

Grid Generd assets

  • Reference (field AASREF)

This group box is managed through the setup of the Numbering for split field.

  • If the field is set to None, the group box must be filled.
  • If the field is set to New Number, the entry of the reference is optional when the automatic numbering is optional, and prohibited when the automatic numbering is mandatory.
  • It is also prohibited when the field is set to By line number increment.
  • Description (field AASDES1)

The description of the created financial asset automatically takes the value of the splitd asset. It can be modified.

  • Quantity (field AASQTY)

Quantity allocated to the generated asset at the end of the splitting.
This quantity is determined automatically by default according to the quantity of the original asset, the distribution type of the splitting and, in the case of a splitting by amount, the choice to distribute or not the quantity of the original asset. Thus, the determined value remains modifiable.

  • Percentage (field SPLPRC)

Percentage of the amount allocated to the asset coming from the splitting.
When the split is carried out by Amount and that the flag Percentage to distribute is activated, the modification of this percentage is authorized and results in a new calculation of the amount allocated to the asset coming from the split as well as the amount allocated to the original asset.

  • Amount (field SPLAMT)

Amount allocated to the asset coming from the splitting.

  • If the split is carried out by distribution of the quantity or the expenses, this amount corresponds to the GCA Ex. tax entry value of the asset, expressed in company currency or to the Ex tax IAS/IFRS entry value in company currency, if the Ex tax GCA entry value is equal to 0.
  • If the split is carried out by amount, this amount corresponds to the one specified for the distribution.

This amount automatically calculated can still be modified as the total of the amounts of the generated assets remains inferior to the amount of the original asset before the split.
- When the split is carried out by distribution of the amount and that the flag Percentage to distribute is activated, the modification of the amount can be obtained by adjusting the percentage to distribute.
In case of modification, the difference between the value calculated and the one coming from the modification is, according to the case, added of withdrawn from the amount of the original asset after split.
- When the split is carried out by distributing the quantity, the Amounts distributed is used to re-calculate the amount of each asset, pro rata to the entered quantities.

Close

 

Setup of the split

The first stageconsists in specifying the split method. It means defining whether the split takes place by distribution of the quantity, by distribution of an amount -of which it is necessary to specify the nature - or by distribution of the attached expenses, then by specifying the total number of assets expected at the end of the split (this quantity includes the asset at the origin of the split).

1/ Split by distribution of the quantity

This type of split is authorized if the asset quantity is larger than or equal to 2. If this quantity is larger than 2, this type of split is only authorized if the quantity is expressed in a unit accepting decimal digits.

Special features: When the asset is linked to several expenses with at least one expense linked to a subsidized investment project, the split by distribution of the quantity is authorized only if the expense split has been requested (see the paragraph below Impact on expenses).

The number of assets to create must be indicated; the maximum number of resulting assets cannot exceed the original asset quantity.

The Distribute qty check box is automatically active and cannot be deactivated.

Quantities and Amounts assigned to the assets from the split

  • The quantity specified for each of the assets obtained at the end of the split is calculated by distributing the quantity of the original asset. The quantities obtained are rounded according to the unit; the balance is assigned to the original asset. These quantities remain modifiable by the user in so far as the sum of the quantities of the generated assets added to the quantity of the original asset after split remains equal to the quantity in the original asset before the split. The quantities entered must be greater than or equal to 1, except if they are expressed in a unit that accepts decimals, in which case they can be between 0 and 1. When a quantity is modified manually for one of the generated assets, select Quantity reportfrom the Action icon in that field to renew these quantities for all generated assets. The residual quantity is assigned to the original asset.
  • The amount specified on each asset corresponds to the Ex-tax CoA receipt value in company currency. This amount is calculated in proportion to the number of created assets, based on the ex-tax CoA value of the split asset if the amount is different from 0; if not, it is based on the ex-tax IAS value. Select Distrib amts in the Action panel to re-calculate the CoA ex-tax receipt valuefor each of the assets pro rata of the quantities.
2/ Split by distributing the amount

Special features: when the asset is linked to several expenses with at least one expense linked to a subsidized investment project, the split by distribution of the amount is authorized only if the expense split has been requested (see the paragraph Impact on expenses below).

The distribution can be carried out by choosing the CoA ex-tax receipt value (value by default), the IAS/IFRS ex-tax receipt value, the CoA balance sheet value, the IAS/IFRS balance sheet value, the CoA revaluated balance sheet value or the IAS/IFRS revaluated balance sheet value. This type of split is allowed only if the selected amount is greater than 0.

The number of assets to create must be indicated; the maximum number of resulting assets is limited to 999.

The Distribute quantity check box is activated by default when the quantity is superior to 1. It makes it possible to specify whether the quantity must be distributed between the assets generated at the end of the split. This flag can be deactivated; in this case, the original asset quantity will be equally transferred to each asset generated by the split.

The Distribute in %age check box is active. It authorizes, when activated, the modification of the distribution percentage on each asset coming from the split. Amounts are recalculated after modification to take into account the new distribution.

Quantities and Amounts assigned to the assets from the split:

  • If the asset quantity must be distributed, the quantity linked to each asset will be determined by distributing the original asset quantity and can be modified. The quantities obtained are rounded according to the unit; the balance is assigned to the original asset.
  • If the asset quantity is not distributed, the quantity linked to each asset will be the same as the quantity of the asset to be split, and it can be modified.
  • The amount type displayed on each asset corresponds to the amount of the asset that the user chose as the split reference. This amount is automatically calculated in proportion to the number of created assets.

    It can be modified:

    - Directly, by entering a new amount
    - Or if the Distribute in %age check box has been activated, by changing the distribution percentage of the assets from the split, in which case their amount will be automatically recalculated.

    The modification is authorized if the total of all generated assets amounts remains strictly inferior than the amount of the original asset before the split. The difference between these two values will load the original asset amount after split.
Impact on expenses
  • If the asset is attached to a single expense: the expense is split according to the same rule as the asset. Each asset created at the end of the split will have an expense attached.
  • If the asset is linked to several expenses, there are two possibilities:
    - The expenses are not split (the Split expenses check box is not selected). The expenses are still linked to the original asset, and the assets created further to the split have no linked expenses
    - The expense split has been requested. Each expense is split according to the same rule as the asset. Each asset created further to the expense split will be associated with as many linked expenses as the original asset.

    If at least one of the expenses is linked to a subsidized investment project, the split by distribution of the quantity or amount of the asset is authorized only if the expense split has been requested. It is necessary to ensure that the subsidy amount for each asset is equal to the total of the subsidies associated with the linked expenses.
3/ Split by distributing expenses linked to the asset

This type of distribution is prohibited:
- If the asset is attached to a single expense,
- If the CoA value of the asset is different from the total of the values of the capitalized expenses with respect to the CoA follow-up,
- If the IFRS value of the asset is different from the total of the values of the capitalized expenses with respect to the IFRS follow-up.

The number of assets to be created is automatically determined as a function of the number of expenses, in such a way that the expense is attached to an asset (the main expense remains attached to the original asset). It can be modified but can only take the value 2 (the user must select the expense(s) to be linked to the generated asset in the Linked expenses tab; unchecked expenses remain attached to the original asset).
If the main expense is selected to be attached to a generated asset, it is the first of the unselected expenses in the list that will become the new main expense attached to the original asset.
The Distribute in %age is deactivated and cannot be accessed.

Quantities and Amounts assigned to the assets from the split:

  • If the split is carried out with the creation of one asset per expense, the quantity of each of the assets from the split is equal to the quantity that appears in the expense to which it is attached ; this quantity remains modifiable.
  • If the created asset is linked to several expenses, the quantity of the generated asset is equal to the total of the linked expenses quantities and can be modified.
  • The amount of each asset originating from the split is equal to the amount of the linked expense, or to the total of linked expenses amounts if several expenses are linked to the asset.

The second stage is to set up the numbering mode to apply to the asset originating from the split. The following options are available:

  • Nonemeans that no automatic numbering is applied. The reference must be entered by the user in the Generated assets table. The Incrementfield cannot be entered.
    This option is not available if the automatic numbering has been defined as being mandatory based on the ASSAUTNUM - Financial asset numbering parameter setting.
  • Add a numeric increment means automatically assigning a reference identical to that of the original asset with the addition of an Increment for which a value must be entered.
  • New number means that a new reference will be assigned to each of the asset resulting from the split. This reference is automatically generated during the entry of the split for the original asset and cannot be entered if the automatic numbering is defined as being mandatory based on the ASSAUTNUM - Financial asset numbering parameter setting.. If the automatic numbering is defined as being optional, the reference of the new assets can be entered in the Generated assets table.
    The New number option is only available if a sequence number counter has been assigned to the Asset object in the parameters. For further information, see the Sequence number assignment documentation.

Setting up the split

Select Split in the Action panel to begin the process.

It loads:

  • The Quantity and Amount information after the split of the original asset.
  • The Generated assets gird, with as many lines as there are created assets.

For each asset, the information is entered as follows:

Reference: Depending on the setup carried out at the level of the Numbering for the split field, the reference can be entered automatically or must be entered.

Description: the description of each of the assets generated is automatically loaded with the description of the original asset. You can modify it.

Quantity: The quantity determined for each of the assets depends on the type of split. See detail above, at the level of the Setting up the split paragraph.

Amount: The amount type corresponds to that selected by the user as the basis of the split if the split has been carried out by distribution of an amount,or to the CoA Ex-tax receipt value in the company currency (or to the Ex-tax IAS/IFRS entry value if the ex-tax CoA entry value is equal to 0) if the split has been carried out by distribution of the quantity or by expenses.
- The amount calculated for each of the assets is a function of the split type. See the detail of the calculation above at the level of the paragraph Setting up the split.
This amount, compared with that of the original asset before the split, is used to determine a ratio used to calculate the distribution of the other asset amounts.
- The +/- sign for the Ex-tax amount for each of the lines must be identical to the sign of the Ex-tax amount of the asset to be split.
- An asset generated by a split may have a zero amount.

Rules linked to the fields of the type Amount:

- The VAT amounts - VAT collected for the asset, from its depreciation plans and its events - are distributed on the basis of the ratio obtained between the amounts of each of the generated assets and the amount of the original asset before the split (the amount taken into account for the ratio calculation corresponds, either to the CoA receipt value in company currency (or to the Ex-tax IAS/IFRS entry value if the Ex-tax CoA entry value is equal to 0) if the split is carried out by quantity or by expenses, or on the basis of an amount specified by the user if the split is carried out by the distribution of an amount).

- the Free fields of the type Amount are distributed if the setup of the Properties of the free fields allows it.

Rules linked to the status of the generated assets:

The status of these assets depends on that of the original asset:

Split of an asset with the status Autonomous

The assets from the split of an autonomous asset will have the Autonomous status and will have no link to the original asset.

Split of an asset with the status Principal

The asset from the split of a principal asset will have the Component status and will be attached to this principal asset.

Split of an asset with the Component status (or Component waiting attachment)

The assets coming from the split of an asset which status is Component (or Component waiting attachment), will have the same status and will be linked to the same principal asset, if the link to a principal asset exists.

Impact on the events

All events linked to an original asset are transferred to the generated assets. The amounts are split and recalculated on the same split bases as the asset.
In case of split of the linked expenses, the amounts of their associated events are split too.

Tab Linked expenses

Presentation

This tab presents the list of expenses attached to the asset to be split. It is used in the case of a split by the distribution of the expenses to select those expenses to be linked to the generated asset.
The table displays the re-evaluated balance sheet value of the original asset before and after split, for each relevant plan.

Summary of the rules for the linking of expenses during a split
  • Split by distribution of the quantity or the amount of an asset linked to a single expense: the expense is split according to the same rule as the asset. Each asset created at the end of the split will have an expense attached.
  • Split by distribution of the quantity or the amount for an asset linked to several expenses:
    - If the expense split has not been requested, the assets created further to the split will have no attached expense. This type of split is prohibited when at least one of the expenses is linked to a subsidized investment project.
    - If the expense split has been requested, each of the assets created further to the spilt will have as many attached expenses as the original asset.
  • Split by distribution of the expenses: the number of assets generated is automatically determined so that each asset can be attached to an expense (the main expense remains attached to the original asset). When the asset is attached to more than 2 expenses, the user can modify this number and choose to split the asset in 2.

    In the latter case, the user must select the expenses to be linked to the generated asset in this tab. Unchecked expenses remain attached to the original asset.

    Note: If the main expense is selected to be attached to a generated asset, it is the first of the unselected expenses on the list that will become the new main expense attached to the original asset.
Example of a split by distribution of the expenses: A financial asset is attached to 4 expenses.

During the operation of the split by expenses, the system will automatically propose to split the asset in 4; the original asset attached to the main expense and the 3 assets attached to it, each attached to one of the three other expenses.

If the user does not wish to slip the asset into 4, the other alternative is to split it into 2. In this tab, the user can select the expenses to be attached to the generated asset; non selected expenses will remain linked to the original asset.

If the user wants to split the asset in 3, he/her must first split the asset in 2 by selecting the expenses to link to the generated asset so that at least 2 expenses remain attached to the original asset. It will then be necessary to split the original asset into 2 again.

The user still has the possibility to split the asset by quantity or amount while also requesting the split of expenses.

 

Fields

The following fields are present on this tab :

Grid Linked expenses

  • Selection (field SELFLG)

This check box cannot be accessed when splitting an asset with physical elements.
It is used in the event of a split by distribution of the expenses to select those to be linked to the generated asset. Refer to the documentation on the Splitting function.

  • P (field MAIFLG)

This non-editable indicator specifies whether the expense is the principal expense of the source asset.
After the split the principal expense remains linked to the source asset.

  • Reference (field CODLOF)
Reference of the expense linked to the asset to be split.
  • Line number (field LINLOF)

This field reminds the user of the line number of the expense.

  • Description (field OBJDES)
Description of the expense linked to the asset to be split.
  • Quantity (field QTY)
Quantity carried by the expense linked to the asset to be split.
  • Amt for split (field SPLAMT)
Amount carried by the expense linked to the asset to be split.
  • Free field 1 amount before (field USRFLD1B)

 

  • Free field amount 1 (field USRFLDM1)

 

 

Validation of the splitting process

Select OK to validate the chosen setup and to return to the original asset, displayed with its new values.
The assets from the split will not be created in the database until after the validation. They will appear in the left list after refreshing it using the F5 key your keyboard.

The asset which has been split, as well as assets coming from the split, can be identified in the Fixed asset management function, at the level of the Other info tab:
- The Splitcheck box is set to Yes for the split asset.
- Assets from the split have the value Entry origin: Split. They inherit the same group number as the split asset's (if there are successive splits, the group number of the original asset is kept). The list of assets generated from the slip can thus be accessed in the Assets of the group section of the Assets management function.

Specific buttons

This button is used to split the asset by applying the entered parameters. The assets resulting from the split are displayed in the Generated assets table.

This button is accessible onlyafter a split carried out by distribution of the quantity.
It is used to recalculate the ex-tax amount of each asset in proportion to the new quantities entered.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Invalid number of splits

The number of assets coming from the split must be greater than or equal to 2.

  • In the case of a split by distribution of the amount, the maximum number of assets from the split is limited to 999.
  • In the case of a split by distribution of the quantity, it is mandatory that the number of assets from the split is less than or equal to the quantity carried by the asset to be split.
  • In the case of a split by expense, the maximum number of assets from the split is limited to the number of expenses.
Split not possible: asset only attached to one physical asset and the number of expenses is <2

In this situation, you need to link at least one additional physical asset to the fixed asset. This allows the split of asset by physical asset.

Failure when recording the split

This error linked to a defect in the database. If the problem continues, please contact support.

Tables used

SEEREFERTTO Refer to documentation Implementation